/*
 Navicat Premium Data Transfer

 Source Server         : mysql-native
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : 127.0.0.1:3306
 Source Schema         : msg_test

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 15/03/2021 18:56:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for msg_log
-- ----------------------------
DROP TABLE IF EXISTS `msg_log`;
CREATE TABLE `msg_log` (
  `msg_id` varchar(255) NOT NULL COMMENT '消息唯一标识',
  `msg` text COMMENT '消息体, json格式化',
  `exchange` varchar(255) NOT NULL DEFAULT '' COMMENT '交换机',
  `routing_key` varchar(255) NOT NULL DEFAULT '' COMMENT '路由键',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态: 0投递中 1投递成功 2投递失败 3已消费',
  `try_count` int NOT NULL DEFAULT '0' COMMENT '重试次数',
  `next_try_time` datetime DEFAULT NULL COMMENT '下一次重试时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='消息投递日志';

-- ----------------------------
-- Records of msg_log
-- ----------------------------
BEGIN;
INSERT INTO `msg_log` VALUES ('32ad873c0ea2432e8a420770e2ef2a79', '{\"to\":\"976058346@qq.com\",\"title\":\"刘洋美好的一天rrrr\",\"content\":\"今天去游泳好开心啊333\",\"msgId\":\"32ad873c0ea2432e8a420770e2ef2a79\"}', 'mail.exchange', 'mail.routing.key', 3, 0, NULL, '2021-03-15 16:43:02', '2021-03-15 16:43:03');
INSERT INTO `msg_log` VALUES ('3ed98b86d22c4322b3cec445b328d713', '{\"to\":\"1257810147@qq.com\",\"title\":\"刘洋的一天\",\"content\":\"明天见\",\"msgId\":\"3ed98b86d22c4322b3cec445b328d713\"}', 'mail.exchange', 'mail.routing.key', 1, 0, NULL, '2021-03-15 15:47:36', '2021-03-15 15:47:36');
INSERT INTO `msg_log` VALUES ('5a86ebce3dce4dc5a31794304f9a69fa', '{\"to\":\"1257810147@qq.com\",\"title\":\"刘洋的一天\",\"content\":\"明天见\",\"msgId\":\"5a86ebce3dce4dc5a31794304f9a69fa\"}', 'mail.exchange', 'mail.routing.key', 1, 0, NULL, '2021-03-15 16:02:58', '2021-03-15 16:02:58');
INSERT INTO `msg_log` VALUES ('603ccdb70ea74b00a7da745a514922bd', '{\"to\":\"976058346@qq.com\",\"title\":\"刘洋美好的一天rrrr\",\"content\":\"今天去游泳好开心啊333\",\"msgId\":\"603ccdb70ea74b00a7da745a514922bd\"}', 'mail.exchange', 'mail.routing.key', 3, 0, NULL, '2021-03-15 17:44:12', '2021-03-15 17:44:13');
INSERT INTO `msg_log` VALUES ('74c8112a1cea4ee9ba5be14bb4cb47f6', '{\"to\":\"1257810147@qq.com\",\"title\":\"刘洋的一天\",\"content\":\"明天见\",\"msgId\":\"74c8112a1cea4ee9ba5be14bb4cb47f6\"}', 'mail.exchange', 'mail.routing.key', 1, 0, NULL, '2021-03-15 16:13:18', '2021-03-15 16:13:18');
INSERT INTO `msg_log` VALUES ('93d09bc0158f477cb18462a2c8ef9570', '{\"to\":\"976058346@qq.com\",\"title\":\"刘洋美好的一天\",\"content\":\"今天去游泳好开心啊\",\"msgId\":\"93d09bc0158f477cb18462a2c8ef9570\"}', 'mail.exchange', 'mail.routing.key', 3, 0, NULL, '2021-03-15 16:40:52', '2021-03-15 16:40:53');
INSERT INTO `msg_log` VALUES ('ae43629d7d414c85a7a3a71aaeba8795', '{\"to\":\"976058346@qq.com\",\"title\":\"刘洋美好的一天\",\"content\":\"今天去游泳好开心啊\",\"msgId\":\"ae43629d7d414c85a7a3a71aaeba8795\"}', 'mail.exchange', 'mail.routing.key', 3, 0, NULL, '2021-03-15 16:38:00', '2021-03-15 16:38:02');
INSERT INTO `msg_log` VALUES ('b62e69a892d4494aaed23519e0439c69', '{\"to\":\"976058346@qq.com\",\"title\":\"刘洋美好的一天rrrr\",\"content\":\"今天去游泳好开心啊333\",\"msgId\":\"b62e69a892d4494aaed23519e0439c69\"}', 'mail.exchange', 'mail.routing.key', 3, 0, NULL, '2021-03-15 17:39:39', '2021-03-15 17:39:40');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
